﻿<!DOCTYPE html>
<html>
	<head>
		<title>Set font type, size, style, and colors</title>
		<meta charset="utf-8" />
		<meta name="description" content="Change the following formatting parameters: font type, size, style, and colors" />
		<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
		<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
        <script type="text/javascript" src="../callback.js"></script>
        <script type="text/javascript" src="../search/js/page-search.js"></script>
	</head>
	<body>
		<div class="mainpart">
        <div class="search-field">
            <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
        </div>
			<h1>Set font type, size, style, and colors</h1>
			<p>In the <a href="https://www.onlyoffice.com/spreadsheet-editor.aspx" target="_blank" onclick="onhyperlinkclick(this)"><b>Spreadsheet Editor</b></a>, you can select the font type and its size, apply one of the decoration styles and change the font and background colors by clicking the corresponding icons on the <b>Home</b> tab of the top toolbar.</p>
			<p class="note"><b>Note</b>: if you want to apply formatting to the data in the spreadsheet, select them with the mouse or <a href="../HelpfulHints/KeyboardShortcuts.htm#textselection" onclick="onhyperlinkclick(this)">use the keyboard</a> and apply the required formatting. If you need to apply the formatting to multiple non-adjacent cells or cell ranges, hold down the <b>Ctrl</b> key while selecting cells/ranges with the mouse.</p>
			<table>
				<tr>
					<td width="10%">Font</td>
					<td width="15%"><div class="big big-fontfamily"></div></td>
					<td>Used to select one of the fonts from the list of the available fonts. <span class="desktopDocumentFeatures">If the required font is not available in the list, you can download and install it on your operating system, and the font will be available for use in the <em>desktop version</em>.</span></td>
				</tr>
				<tr>
					<td>Font size</td>
					<td><div class="icon icon-fontsize"></div></td>
					<td>Used to select the preset font size values from the dropdown list (the default values are: 8, 9, 10, 11, 12, 14, 16, 18, 20, 22, 24, 26, 28, 36, 48, 72 and 96).  It's also possible to manually enter a custom value up to 409 pt in the font size field. Press <em>Enter</em> to confirm.</td>
				</tr>
				<tr>
					<td>Increment font size</td>
					<td><div class="icon icon-larger"></div></td>
					<td>Used to change the font size making it one point bigger each time the icon is clicked.</td>
				</tr>
				<tr>
					<td>Decrement font size</td>
					<td><div class="icon icon-smaller"></div></td>
					<td>Used to change the font size making it one point smaller each time the icon is clicked.</td>
				</tr>
				<tr>
					<td>Change case</td>
					<td><div class="icon icon-change_case"></div></td>
					<td>Used to change the font case. <em>Sentence case.</em> - the case matches that of a common sentence. <em>lowercase</em> - all letters are small. <em>UPPERCASE</em> - all letters are capital. <em>Capitalize Each Word</em> - each word starts with a capital letter. <em>tOGGLE cASE</em> - reverse the case of the selected text or the word where the mouse cursor is positioned.</td>
				</tr>
				<tr>
					<td>Bold</td>
					<td><div class="icon icon-bold"></div></td>
					<td>Used to make the font bold making it heavier.</td>
				</tr>
				<tr>
					<td>Italic</td>
					<td><div class="icon icon-italic"></div></td>
					<td>Used to make the font slightly slanted to the right.</td>
				</tr>
				<tr>
					<td>Underline</td>
					<td><div class="icon icon-underline"></div></td>
					<td>Used to make the text underlined with a line going below the letters.</td>
				</tr>
				<tr>
					<td>Strikethrough</td>
					<td><div class="icon icon-strike"></div></td>
					<td>Used to make the text struck out with a line going through the letters.</td>
				</tr>
				<tr>
					<td>Subscript/Superscript</td>
					<td><div class="icon icon-subscripticon"></div></td>
					<td>Allows choosing the <b>Superscript</b> or <b>Subscript</b> option. The <b>Superscript</b> option is used to make the text smaller and place it to the upper part of the text line, e.g. as in fractions. The <b>Subscript</b> option is used to make the text smaller and place it to the lower part of the text line, e.g. as in chemical formulas.</td>
				</tr>
				<tr>
					<td>Font color</td>
					<td><div class="icon icon-fontcolor"></div></td>
					<td>Used to change the color of the letters/characters in cells.</td>
				</tr>
				<tr>
					<td>Fill color</td>
					<td><div class="icon icon-backgroundcolor"></div></td>
					<td>Used to change the color of the cell fill. Using this icon you can apply a <em>solid color</em> fill. The color of the cell fill can also be changed using the <b>Fill</b> section on the <a href="../UsageInstructions/AddBorders.htm" onclick="onhyperlinkclick(this)">Cell settings</a> tab of the right sidebar.</td>
				</tr>
				<tr>
					<td id="colorscheme">Change color scheme</td>
					<td><div class="icon icon-changecolorscheme"></div></td>
					<td>This button is located on the <b>Layout</b> tab. Used to change the default color palette for worksheet elements (font, background, chats and chart elements) selecting from the available options: <b>New Office</b>, <b>Office</b>, <b>Grayscale</b>, <b>Apex</b>, <b>Aspect</b>, <b>Civic</b>, <b>Concourse</b>, <b>Equity</b>, <b>Flow</b>, <b>Foundry</b>, <b>Median</b>, <b>Metro</b>, <b>Module</b>, <b>Odulent</b>, <b>Oriel</b>, <b>Origin</b>, <b>Paper</b>, <b>Solstice</b>, <b>Technic</b>, <b>Trek</b>, <b>Urban</b>, or <b>Verve</b>.</td>
				</tr>
			</table>
			<p><p class="note"><b>Note</b>: it's also possible to apply one of the formatting presets selecting the cell you wish to format and choosing the desired preset from the list on the <b>Home</b> tab of the top toolbar:<br /><br />
				<img alt="Formatting Presets" src="../images/presets.png" />
			   </p>
			<p>To change the font color or use a <em>solid color</em> fill as the cell background,</p>
			<ol>
			<li>select characters/cells with the mouse or the whole worksheet using the <b>Ctrl+A</b> key combination,</li>
				<li>click the corresponding icon on the top toolbar,</li>
				<li>select any color in the available palettes
					<p><img alt="Palette" src="../images/palette.png" /></p>
					<ul>
						<li><b>Theme Colors</b> - the colors that correspond to the selected color scheme of the spreadsheet.</li>
						<li><b>Standard Colors</b> - the default colors set.</li>
						<li>
							You can also apply a <b>custom color</b> using two different options:
							<ul>
								<li>
									<b>Eyedropper</b> - use this option to choose the required color by clicking it in the spreadsheet.
								</li>
								<li>
									<b>More colors</b> - click this caption if the required color is missing among the available palettes. Select the necessary color range moving the vertical color slider and set a specific color dragging the color picker within the large square color field. Once you select a color with the color picker, the appropriate RGB and sRGB color values will be displayed in the fields on the right. You can also define a color on the base of the RGB color model by entering the corresponding numeric values into the <b>R</b>, <b>G</b>, <b>B</b> (red, green, blue) fields or enter the sRGB hexadecimal code into the field marked with the <b>#</b> sign. The selected color appears in the <b>New</b> preview box. If the object was previously filled with any custom color, this color is displayed in the <b>Current</b> box so you can compare the original and modified colors. When the color is defined, click the <b>Add</b> button:
									<p><img alt="Palette - Custom Color" src="../../../../../../common/main/resources/help/en/images/palette_custom.png" /></p>
									<p>The custom color will be applied to the text/cell and added to the <b>Recent colors</b> palette.</p>
								</li>
							</ul>
						</li>
						</ul>
					</li>
			</ol>
			<p>To remove the background color from a certain cell,</p>
			<ol>
				<li>select a cell, or a cell range with the mouse or the whole worksheet using the <b>Ctrl+A</b> key combination,</li>
				<li>click the <b>Fill color</b> <div class = "icon icon-backgroundcolor"></div> icon on the <b>Home</b> tab of the top toolbar,</li>
				<li>select the <div class = "icon icon-nofill"></div> icon.</li>
			</ol>
		</div>
	</body>
</html>
